Stored Procedures [dbo].[BAEEventSetupUpdateQuestion]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@idint4
@eventCodevarchar(15)15
@functionCodevarchar(15)15
@questionvarchar(255)255
@questionTypevarchar(30)30
@requiredbit1
SQL Script
create procedure [dbo].[BAEEventSetupUpdateQuestion] @id int,
     @eventCode varchar(15),
     @functionCode varchar(15),
     @question varchar(255),
     @questionType varchar(30),
     @required bit as
UPDATE EventSetupQuestion
    SET EventCode = @eventCode, FunctionCode = @functionCode, Question = @question,
        QuestionType =  @questionType,  Required = @required
    WHERE EventSetupQuestionID = @id;

GO
Uses